USE [BKI_BoiThuongDat]
GO

ALTER PROCEDURE pr_DM_LOAI_HANG_MUC_select_by_lev
@dc_level NUMERIC
AS
SELECT
	dlhm.ID,
	dlhm.MA_LOAI,
	dlhm.TEN_LOAI,
	dlhm.ID_LOAI_CHA,
	dlhm.LEVEL_TREN_CAY,
	dlhm.LA_LA_YN,
	dlhm.SO_THU_TU
FROM
	DM_LOAI_HANG_MUC dlhm
WHERE (dlhm.LEVEL_TREN_CAY = @dc_level OR @dc_level = 0)
ORDER BY dlhm.SO_THU_TU

GO
